Date functions allow you to convert numbers to dates (which you can then format to display as you wish) and to convert dates to numbers.
TimeSerial (hour, minute, second)
DateAdd (intervalType, nIntervals, startDateTime)
First Day of Week/Year constants
DTSTo2000 (DateString, Number)
DTSToTimeString (DateTimeString)
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |